package com.example.screen_data.movie;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;

@Mapper
public interface AppDao {

    @Select("select * from movie_main")
    Map<String, Object> getData0();

    @Select("select * from movie_date order by date")
    List<Map<String, Object>> getData1();

    List<Map<String, Object>> getData2();

    @Select("select actors as name, atr_rating_cnt as value from movie_actor")
    List<Map<String, Object>> getData3();

    @Select("select directors as name, dtr_rating_cnt as value from movie_director")
    List<Map<String, Object>> getData4();

    @Select("select * from movie_genre")
    List<Map<String, Object>> getData5();

    @Select("select * from movie.movie_list order by release_date")
    List<Map<String, Object>> getData6();
}
